/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.cxhd.dc.tool;

/**
 *
 * @author Administrator
 */
public class SqlFile {

    public final static String dataConfig = "CREATE TABLE `dataconfig` (\n"
            + "`pk`  int(11) NOT NULL AUTO_INCREMENT ,\n"
            + "`name`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`value`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`flag`  int(2) NULL DEFAULT NULL ,\n"
            + "`other1`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`other2`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`other3`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "PRIMARY KEY (`pk`),\n"
            + "UNIQUE INDEX `u` (`name`) USING BTREE \n"
            + ")\n"
            + "ENGINE=InnoDB\n"
            + "DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci\n"
            + "AUTO_INCREMENT=1\n"
            + "ROW_FORMAT=COMPACT ";

    public final static String logStudy = "CREATE TABLE `logstudy` (\n"
            + "`pk`  int(11) NOT NULL AUTO_INCREMENT ,\n"
            + "`from_sn`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`createtime`  datetime NULL DEFAULT NULL ,\n"
            + "`study_iuid`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`pat_id`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`pat_name`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`report_status`  int(2) NULL DEFAULT 0 COMMENT '0没有报告1发送报告' ,\n"
            + "`report_date`  datetime NULL DEFAULT NULL ,\n"
            + "`other1`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`other2`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`other3`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`other4`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`other5`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,\n"
            + "`modality`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备类型' ,\n"
            + "`file_starttime`  datetime NULL DEFAULT NULL ,\n"
            + "PRIMARY KEY (`pk`),\n"
            + "UNIQUE INDEX `uuid` (`study_iuid`) USING BTREE \n"
            + ")\n"
            + "ENGINE=InnoDB\n"
            + "DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci\n"
            + "AUTO_INCREMENT=1\n"
            + "ROW_FORMAT=COMPACT";

}
